Michael Culley
Michael Culley
-
Re: Automated Workflow - Copy Rows
Click on the "Run once" and change it to custom then weekly. Also you may need a condition if I'm not mistaken. Maybe something easy like if a column is not blank type of thing. Pick a colu…1 · -
Re: Use of IF AND OR ISBLANK
Awesome good to hear. Just know with nested Or/And statements you want to think of whether you want the AND inside the OR, or the other way around. If you want A and (B or C) That would be IF(AND(A,O…1 · -
Re: Use of IF AND OR ISBLANK
I think you meant to do this: =IF(OR(ISBLANK([End Date]@row), AND([Start Date]@row > TODAY(), [End Date]@row > TODAY())), "Pending", "Complete")1 · -
Re: How to calculate hours for tasks marked 100%?
you would use .50 for 50% and .25 for 25%. So instead of doing =sumif([Task % Complete]:[Task % Complete], 1,[total ETS effort]:[total ETS effort]) You would do =sumif([Task % Complete]:[Task % Compl…1 · -
Re: How to calculate hours for tasks marked 100%?
That would be =sumif([Task % Complete]:[Task % Complete], 1,[total ETS effort]:[total ETS effort])1 ·
